package com.data.app.pojo.pg;

import com.data.app.commons.constant.CommonConstant;
import lombok.Data;
import lombok.ToString;
import org.geolatte.geom.Geometry;

import javax.persistence.*;
import java.math.BigDecimal;
import java.math.BigInteger;
import java.sql.Timestamp;
import java.util.Objects;

@Data
@Entity
//@Table(name = "risk_census_city_non_house", schema = "public", catalog = "sharedata")
@Table(name = CommonConstant.TABLE_NAME_CITY_NO_HOUSE, schema = "public", catalog = "sharedata")
public class CityNonHouseEntity {
    @Id
    @Column(name = "bh", nullable = true, length = -1)
    private String bh;//唯一主键
    @Column(name = "province", nullable = true, length = -1)
    private String province;//省（市 区）
    @Column(name = "city", nullable = true, length = -1)
    private String city;//市（州 盟）
    @Column(name = "district", nullable = true, length = -1)
    private String district;//县（市 区 旗）
    @Column(name = "town", nullable = true, length = -1)
    private String town;//乡（镇街道）
    @Column(name = "village", nullable = true, length = -1)
    private String village;//社区
    @Column(name = "mc", nullable = true, length = -1)
    private String mc;//小区名称
    @Column(name = "jzmc", nullable = true, length = -1)
    private String jzmc;//建筑名称
    @Column(name = "address", nullable = true, length = -1)
    private String address;//建筑地址
    @Column(name = "dscs", nullable = true, length = -1)
    private Integer dscs;//地上层数
    @Column(name = "dxcs", nullable = true, length = -1)
    private Integer dxcs;//地下层数
    @Column(name = "dcmj", nullable = true, length = -1)
    private BigDecimal dcmj;//建筑面积
    @Column(name = "gd", nullable = true, length = -1)
    private BigDecimal gd;//建筑高度
    @Column(name = "buildTime", nullable = true, length = -1)
    private String buildTime;//建成时间
    @Column(name = "sfcqdj", nullable = true, length = -1)
    private String sfcqdj;//是否产权登记
    @Column(name = "cqdw", nullable = true, length = -1)
    private String cqdw;//产权单位
    @Column(name = "czfwjglx", nullable = true, length = -1)
    private String czfwjglx;//结构类型
    @Column(name = "fwyt", nullable = true, length = -1)
    private String fwyt;//建筑用途
    @Column(name = "sfcyjgz", nullable = true, length = -1)
    private String sfcyjgz;//是否采用减隔震
    @Column(name = "sfszcg", nullable = true, length = -1)
    private String sfszcg;//是否进行过改造
    @Column(name = "gzsj", nullable = true, length = -1)
    private String gzsj;//改造时间
    @Column(name = "sfkzjg", nullable = true, length = -1)
    private String sfkzjg;//是否进行过抗震加固
    @Column(name = "jgsj", nullable = true, length = -1)
    private String jgsj;//抗震加固时间
    @Column(name = "ywlfbxqx", nullable = true, length = -1)
    private String ywlfbxqx;//变形损伤（ 有无明显裂缝、倾斜、变形等）
    @Column(name = "jzsfld", nullable = true, length = -1)
    private BigDecimal jzsfld;//原设防烈度
    @Column(name = "mqsfld", nullable = true, length = -1)
    private BigDecimal mqsfld;//现设防烈度
    @Column(name = "jzsflb", nullable = true, length = -1)
    private String jzsflb;//原设防类别
    @Column(name = "mqsflb", nullable = true, length = -1)
    private String mqsflb;//现设防类别
    @Column(name = "sfbhxjz", nullable = true, length = -1)
    private String sfbhxjz;//是否保护性建筑
    @Column(name = "sfzysjjz", nullable = true, length = -1)
    private String sfzysjjz;//是否专业设计建造
    @Column(name = "shape", nullable = true, length = -1)
    private Geometry shape;//矢量面
    @Column(name = "fxpc_xzqhbma_sjgl", nullable = true, length = -1)
    private String fxpcXzqhbmaSjgl;//行政区划编码省
    @Column(name = "fxpc_xzqhbmb_sjgl", nullable = true, length = -1)
    private String fxpcXzqhbmbSjgl;//行政区划编码市
    @Column(name = "fxpc_xzqhbmc_sjgl", nullable = true, length = -1)
    private String fxpcXzqhbmcSjgl;//行政区划编码县
    @Column(name = "fxpc_updatetime_sjgl", nullable = true, length = -1)
    private String fxpcUpdatetimeSjgl;//更新时间
    @Column(name = "fxpc_createtime_sjgl", nullable = true, length = -1)
    private String fxpcCreatetimeSjgl;//写入时间
    @Column(name = "fxpc_sjzt_sjgl", nullable = true, length = -1)
    private String fxpcSjztSjgl;//数据状态
    @Column(name = "fxpc_shlczt_sjgl", nullable = true, length = -1)
    private String fxpcShlcztSjgl;//审核流程状态
    @Column(name = "fxpc_shzt_sjgl", nullable = true, length = -1)
    private String fxpcShztSjgl;//审核状态
    @Column(name = "fxpc_sshy_sjgl", nullable = true, length = -1)
    private String fxpcSshySjgl;//所属行业
    @Column(name = "fxpc_rqfp_sjgl", nullable = true, length = -1)
    private String fxpcRqfpSjgl;//日期分片
    @Column(name = "fxpc_pch_sjgl", nullable = true, length = -1)
    private String fxpcPchSjgl;//批次号
    @Column(name = "fxpc_dcdxbm_sjgl", nullable = true, length = -1)
    private String fxpcDcdxbmSjgl;//调查对象编码
    @Column(name = "fxpc_dataid_sjgl", nullable = true, length = -1)
    private String fxpcDataidSjgl;//物理主键

}
